﻿<List Title="ProductSID" Url="Lists/ProductSID" BaseType="0" Type="100" Name="ProductSID"
      DisableAttachments="TRUE" FolderCreation="FALSE" VersioningEnabled="FALSE" EnableContentTypes="TRUE"
      xmlns="http://schemas.microsoft.com/sharepoint/">
  <MetaData>
    <ContentTypes>
      <ContentType ID="0x01003b7743e4960c4618865f01f122aeb500"
               Name="ConsolidationTool_ProductSID"
               Group="ConsolidationTool"
               Description="Custom Content Type">
        <FieldRefs>
          <FieldRef Name="Title" ID="{CA58E128-6868-45D8-828D-55B420DBEA47}"/>
          <FieldRef Name="LinkTitle" ID="{CA58E128-6868-45D8-828D-55B420DBEA48}"/>
          <FieldRef Name="Region" ID="{CA58E128-6868-45D8-828D-55B420DBEA49}"/>
          <FieldRef Name="SubRegion" ID="{CA58E128-6868-45D8-828D-55B420DBEA50}"/>
          <FieldRef Name="Entity" ID="{CA58E128-6868-45D8-828D-55B420DBEA51}"/>
          <FieldRef Name="Qty_YTDLM" ID="{CA58E128-6868-45D8-828D-55B420DBEA52}"/>
          <FieldRef Name="InvoiceCurrency_YTDLM" ID="{CA58E128-6868-45D8-828D-55B420DBEA53}"/>
          <FieldRef Name="InvoiceAmount_YTDLM" ID="{CA58E128-6868-45D8-828D-55B420DBEA54}"/>
          <FieldRef Name="BookAmount_YTDLM" ID="{CA58E128-6868-45D8-828D-55B420DBEA55}"/>
          <FieldRef Name="Qty" ID="{CA58E128-6868-45D8-828D-55B420DBEA56}"/>
          <FieldRef Name="InvoiceCurrency" ID="{CA58E128-6868-45D8-828D-55B420DBEA57}"/>
          <FieldRef Name="InvoiceAmount" ID="{CA58E128-6868-45D8-828D-55B420DBEA58}"/>
          <FieldRef Name="BookAmount" ID="{CA58E128-6868-45D8-828D-55B420DBEA59}"/>
          <FieldRef Name="EntityData" ID="{CA58E128-6868-45D8-828D-55B420DBEA60}"/>
          <FieldRef Name="RGC" ID="{CA58E128-6868-45D8-828D-55B420DBEA61}"/>
          <FieldRef Name="Year" ID="{CA58E128-6868-45D8-828D-55B420DBEA62}"/>
          <FieldRef Name="Month" ID="{CA58E128-6868-45D8-828D-55B420DBEA63}"/>
        </FieldRefs>

      </ContentType>
    </ContentTypes>

    <Fields>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA47}" Type="Text"  DisplayName="Title"  Name="Title"   StaticName="Title" Required="TRUE"   Indexed="TRUE" EnforceUniqueValues="true" />
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA48}" Type="Computed"  DisplayName="Title" Name="LinkTitle"  StaticName="LinkTitle" ReadOnly="TRUE"></Field>

      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA49}" Type="Lookup" List="Lists/Region"  DisplayName="Region" ShowField="Title" Name="Region"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA50}" Type="Lookup" List="Lists/SubRegion"  ShowField="Title"  DisplayName="SubRegion"  Name="SubRegion"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA51}" Type="Lookup" List="Lists/Entity" DisplayName="Entity"  Name="Entity"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA52}" Type="Number" DisplayName="Qty YTD M-1" Name ="Qty_YTDLM" />
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA53}" Type="Number" DisplayName="Invoice Currency YTD M-1" Name ="InvoiceCurrency_YTDLM"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA54}" Type="Number" DisplayName ="Invoice Amount YTD M-1" Name="InvoiceAmount_YTDLM"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA55}" Type="Number" DisplayName ="Book Amount YTD M-1" Name="BookAmount_YTDLM"/>

      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA56}" Type="Number" DisplayName="Qty" Name ="Qty" />
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA57}" Type="Number" DisplayName="Invoice Currency" Name ="InvoiceCurrency"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA58}" Type="Number" DisplayName ="Invoice Amount" Name="InvoiceAmount"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA59}" Type="Number" DisplayName ="Book Amount" Name="BookAmount"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA60}" Type="Lookup" List="Lists/Entity" ShowField="Title" DisplayName="EntityData" Name ="EntityData" />
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA61}" Type="Lookup" List="Lists/RGC" ShowField="Title" DisplayName="RGC" Name ="RGC" />
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA62}" Type="Integer" DisplayName="Year" Name="Year"/>
      <Field ID="{CA58E128-6868-45D8-828D-55B420DBEA63}" Type="Integer" DisplayName="Month" Name="Month"/>
    </Fields>
    <Forms>
      <Form Type="DisplayForm" Url="DispForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="EditForm" Url="EditForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="NewForm" Url="NewForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
    </Forms>

    <Views>
      <View DisplayName="All Items" DefaultView="TRUE" BaseViewID="1" Type="HTML"
            WebPartZoneID="Main" WebPartOrder="1" Url="AllItems.aspx" SetupPath="pages\viewpage.aspx" >
        <XslLink>main.xsl</XslLink>
        <ViewFields>
          <FieldRef Name="LinkTitle"/>
          <FieldRef Name="ParentForm"/>
          <FieldRef Name="Region"/>
          <FieldRef Name="SubRegion"/>
          <FieldRef Name="Entity"/>
          <FieldRef Name ="Qty" />
          <FieldRef Name ="InvoiceCurrency" />
          <FieldRef Name ="InvoiceAmount" />
          <FieldRef Name ="BookAmount" />
        </ViewFields>
        <RowLimit Paged="TRUE">30</RowLimit>
      </View>
    </Views>
  </MetaData>
</List>
